Opened 12 years ago

Closed 12 years ago

Last modified 12 years ago

#1840 closed defect (fixed)

[raster] raster2pgsql does not tile correcly when tile-width is equal raster-width

Reported by: turbothomas Owned by: dustymugs
Priority: medium Milestone: PostGIS 2.0.1
Component: raster Version: 2.0.x
Keywords: raster2pgsql, tile_size, history Cc:

Description

I was trying to load a long thin raster using raster2pgsql. When I set the tile width to the width of the raster, changing only the height, only one tile was loaded; the rest of the raster was missing. If the tile size was smaller or bigger than the raster size, the entirer raster was loaded correctly.

Change History (8)

comment:1 by dustymugs, 12 years ago

Component: loader/dumperraster
Owner: changed from mcayland to dustymugs
Summary: raster2pgsql does not tile correcly when tile-width is equal raster-width[raster] raster2pgsql does not tile correcly when tile-width is equal raster-width

comment:2 by dustymugs, 12 years ago

Can you provide the flags and parameters you're using when calling raster2pgsql?

in reply to:  2 ; comment:3 by turbothomas, 12 years ago

Replying to dustymugs:

Can you provide the flags and parameters you're using when calling raster2pgsql?

I was using subdataset2 (now extracted with gdal_transform -sds) from file listed in comments of #1839

raster2pgsql.exe -s 0 -I -C -M myraster.tif -F -t 392x496 mypostgisraster > raster.sql

using windows 7, 64-bit

in reply to:  3 comment:4 by turbothomas, 12 years ago

when using -t 393x496 it works fine

comment:5 by dustymugs, 12 years ago

Status: newassigned

comment:6 by dustymugs, 12 years ago

Resolution: fixed
Status: assignedclosed

Fixed in r9808 for 2.0.x.

comment:7 by dustymugs, 12 years ago

Fixed for 2.1 in r9810

comment:8 by dustymugs, 12 years ago

Keywords: history added
Note: See TracTickets for help on using tickets.